SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{8dd5bcac043de5b9189c996ebda07f5a53955670c0dc35a8fd413de2784658dd}Cancelada{8dd5bcac043de5b9189c996ebda07f5a53955670c0dc35a8fd413de2784658dd}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{8dd5bcac043de5b9189c996ebda07f5a53955670c0dc35a8fd413de2784658dd}Cancelada{8dd5bcac043de5b9189c996ebda07f5a53955670c0dc35a8fd413de2784658dd}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{8dd5bcac043de5b9189c996ebda07f5a53955670c0dc35a8fd413de2784658dd}Spain{8dd5bcac043de5b9189c996ebda07f5a53955670c0dc35a8fd413de2784658dd}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{8dd5bcac043de5b9189c996ebda07f5a53955670c0dc35a8fd413de2784658dd}Spain{8dd5bcac043de5b9189c996ebda07f5a53955670c0dc35a8fd413de2784658dd}' OR prCountry = 'Spain')